using System;
using System.Data;
using System.Data.SqlClient;
using <Application>.Models;

namespace <Application>.Data
{
    public class <TableU>Data
    {

        public static DataTable SelectAll()
        {
            SqlConnection connection = <Database>Data.GetConnection();
            string selectStatement
                = "SELECT "  
            <If Loop>
               <IsCurRow=[0]>
                + "     [<Owner>].[<Table>].[<Field>] "
               <IsCurRow<>[0]>
                + "    ,[<Owner>].[<Table>].[<Field>] "
            </If Loop>
                + "FROM " 
                + "     [<Owner>].[<Table>] " 
                + "";
            SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
            selectCommand.CommandType = CommandType.Text;
            DataTable dt = new DataTable();
            try
            {
                connection.Open();
                SqlDataReader reader = selectCommand.ExecuteReader();
                if (reader.HasRows) {
                    dt.Load(reader); }
                reader.Close();
            }
            catch (SqlException)
            {
                return dt;
            }
            finally
            {
                connection.Close();
            }
            return dt;
        }

        public static DataTable Search(string sField, string sCondition, string sValue)
        {
            SqlConnection connection = <Database>Data.GetConnection();
            string selectStatement = "";
            if (sCondition == "Contains") {
                selectStatement
                    = "SELECT "
            <If Loop>
               <IsRelated>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow=[0]>
                + "     [A<MiscTag>].[<Field>] as [<Field><MiscTag>]"
               <IsRelated>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow<>[0]>
                + "    ,[A<MiscTag>].[<Field>] as [<Field><MiscTag>]"
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow=[0]>
                + "     [<Owner>].[<Table>].[<Field>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow<>[0]>
                + "    ,[<Owner>].[<Table>].[<Field>] "
               <IsNotRelated>
               <And>
               <IsCurRow=[0]>
                + "     [<Owner>].[<Table>].[<Field>] "
               <IsNotRelated>
               <And>
               <IsCurRow<>[0]>
                + "    ,[<Owner>].[<Table>].[<Field>] "
            </If Loop>
                + "FROM " 
                + "     [<Owner>].[<Table>] " 
            <If Loop>
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNull>
                + "LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNull>
                + "LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNotNull>
                + "INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNotNull>
                + "INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
            </If Loop>
                    + "WHERE " 
<If Loop>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow=[0]>
                    + "     (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] LIKE '%' + LTRIM(RTRIM(@<RDisplayField><MiscTag>)) + '%') " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
                    + "AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] LIKE '%' + LTRIM(RTRIM(@<RDisplayField><MiscTag>)) + '%') " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
                    + "     (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] LIKE '%' + LTRIM(RTRIM(@<RDisplayField>)) + '%') " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
                    + "AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] LIKE '%' + LTRIM(RTRIM(@<RDisplayField>)) + '%') " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
                    + "     (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] LIKE '%' + LTRIM(RTRIM(@<Field>)) + '%') " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
                    + "AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] LIKE '%' + LTRIM(RTRIM(@<Field>)) + '%') " 
</If Loop>
                    + "";
            } else if (sCondition == "Equals") {
                selectStatement
                    = "SELECT "
            <If Loop>
               <IsRelated>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow=[0]>
                + "     [A<MiscTag>].[<Field>] as [<Field><MiscTag>]"
               <IsRelated>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow<>[0]>
                + "    ,[A<MiscTag>].[<Field>] as [<Field><MiscTag>]"
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow=[0]>
                + "     [<Owner>].[<Table>].[<Field>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow<>[0]>
                + "    ,[<Owner>].[<Table>].[<Field>] "
               <IsNotRelated>
               <And>
               <IsCurRow=[0]>
                + "     [<Owner>].[<Table>].[<Field>] "
               <IsNotRelated>
               <And>
               <IsCurRow<>[0]>
                + "    ,[<Owner>].[<Table>].[<Field>] "
            </If Loop>
                + "FROM " 
                + "     [<Owner>].[<Table>] " 
            <If Loop>
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNull>
                + "LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNull>
                + "LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNotNull>
                + "INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNotNull>
                + "INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
            </If Loop>
                    + "WHERE " 
<If Loop>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow=[0]>
                    + "     (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] = LTRIM(RTRIM(@<RDisplayField><MiscTag>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
                    + "AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] = LTRIM(RTRIM(@<RDisplayField><MiscTag>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
                    + "     (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] = LTRIM(RTRIM(@<RDisplayField>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
                    + "AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] = LTRIM(RTRIM(@<RDisplayField>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
                    + "     (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] = LTRIM(RTRIM(@<Field>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
                    + "AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] = LTRIM(RTRIM(@<Field>))) " 
</If Loop>
                    + "";
            } else if  (sCondition == "Starts with...") {
                selectStatement
                    = "SELECT "
            <If Loop>
               <IsRelated>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow=[0]>
                + "     [A<MiscTag>].[<Field>] as [<Field><MiscTag>]"
               <IsRelated>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow<>[0]>
                + "    ,[A<MiscTag>].[<Field>] as [<Field><MiscTag>]"
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow=[0]>
                + "     [<Owner>].[<Table>].[<Field>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow<>[0]>
                + "    ,[<Owner>].[<Table>].[<Field>] "
               <IsNotRelated>
               <And>
               <IsCurRow=[0]>
                + "     [<Owner>].[<Table>].[<Field>] "
               <IsNotRelated>
               <And>
               <IsCurRow<>[0]>
                + "    ,[<Owner>].[<Table>].[<Field>] "
            </If Loop>
                + "FROM " 
                + "     [<Owner>].[<Table>] " 
            <If Loop>
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNull>
                + "LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNull>
                + "LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNotNull>
                + "INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNotNull>
                + "INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
            </If Loop>
                    + "WHERE " 
<If Loop>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow=[0]>
                    + "     (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] LIKE LTRIM(RTRIM(@<RDisplayField><MiscTag>)) + '%') " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
                    + "AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] LIKE LTRIM(RTRIM(@<RDisplayField><MiscTag>)) + '%') " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
                    + "     (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] LIKE LTRIM(RTRIM(@<RDisplayField>)) + '%') " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
                    + "AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] LIKE LTRIM(RTRIM(@<RDisplayField>)) + '%') " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
                    + "     (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] LIKE LTRIM(RTRIM(@<Field>)) + '%') " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
                    + "AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] LIKE LTRIM(RTRIM(@<Field>)) + '%') " 
</If Loop>
                    + "";
            } else if  (sCondition == "More than...") {
                selectStatement
                    = "SELECT "
            <If Loop>
               <IsRelated>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow=[0]>
                + "     [A<MiscTag>].[<Field>] as [<Field><MiscTag>]"
               <IsRelated>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow<>[0]>
                + "    ,[A<MiscTag>].[<Field>] as [<Field><MiscTag>]"
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow=[0]>
                + "     [<Owner>].[<Table>].[<Field>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow<>[0]>
                + "    ,[<Owner>].[<Table>].[<Field>] "
               <IsNotRelated>
               <And>
               <IsCurRow=[0]>
                + "     [<Owner>].[<Table>].[<Field>] "
               <IsNotRelated>
               <And>
               <IsCurRow<>[0]>
                + "    ,[<Owner>].[<Table>].[<Field>] "
            </If Loop>
                + "FROM " 
                + "     [<Owner>].[<Table>] " 
            <If Loop>
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNull>
                + "LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNull>
                + "LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNotNull>
                + "INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNotNull>
                + "INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
            </If Loop>
                    + "WHERE " 
<If Loop>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow=[0]>
                    + "     (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] > LTRIM(RTRIM(@<RDisplayField><MiscTag>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
                    + "AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] > LTRIM(RTRIM(@<RDisplayField><MiscTag>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
                    + "     (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] > LTRIM(RTRIM(@<RDisplayField>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
                    + "AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] > LTRIM(RTRIM(@<RDisplayField>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
                    + "     (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] > LTRIM(RTRIM(@<Field>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
                    + "AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] > LTRIM(RTRIM(@<Field>))) " 
</If Loop>
                    + "";
            } else if  (sCondition == "Less than...") {
                selectStatement
                    = "SELECT " 
            <If Loop>
               <IsRelated>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow=[0]>
                + "     [A<MiscTag>].[<Field>] as [<Field><MiscTag>]"
               <IsRelated>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow<>[0]>
                + "    ,[A<MiscTag>].[<Field>] as [<Field><MiscTag>]"
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow=[0]>
                + "     [<Owner>].[<Table>].[<Field>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow<>[0]>
                + "    ,[<Owner>].[<Table>].[<Field>] "
               <IsNotRelated>
               <And>
               <IsCurRow=[0]>
                + "     [<Owner>].[<Table>].[<Field>] "
               <IsNotRelated>
               <And>
               <IsCurRow<>[0]>
                + "    ,[<Owner>].[<Table>].[<Field>] "
            </If Loop>
                + "FROM " 
                + "     [<Owner>].[<Table>] " 
            <If Loop>
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNull>
                + "LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNull>
                + "LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNotNull>
                + "INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNotNull>
                + "INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
            </If Loop>
                    + "WHERE " 
<If Loop>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow=[0]>
                    + "     (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] < LTRIM(RTRIM(@<RDisplayField><MiscTag>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
                    + "AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] < LTRIM(RTRIM(@<RDisplayField><MiscTag>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
                    + "     (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] < LTRIM(RTRIM(@<RDisplayField>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
                    + "AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] < LTRIM(RTRIM(@<RDisplayField>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
                    + "     (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] < LTRIM(RTRIM(@<Field>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
                    + "AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] < LTRIM(RTRIM(@<Field>))) " 
</If Loop>
                    + "";
            } else if  (sCondition == "Equal or more than...") {
                selectStatement
                    = "SELECT "
            <If Loop>
               <IsRelated>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow=[0]>
                + "     [A<MiscTag>].[<Field>] as [<Field><MiscTag>]"
               <IsRelated>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow<>[0]>
                + "    ,[A<MiscTag>].[<Field>] as [<Field><MiscTag>]"
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow=[0]>
                + "     [<Owner>].[<Table>].[<Field>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow<>[0]>
                + "    ,[<Owner>].[<Table>].[<Field>] "
               <IsNotRelated>
               <And>
               <IsCurRow=[0]>
                + "     [<Owner>].[<Table>].[<Field>] "
               <IsNotRelated>
               <And>
               <IsCurRow<>[0]>
                + "    ,[<Owner>].[<Table>].[<Field>] "
            </If Loop>
                + "FROM " 
                + "     [<Owner>].[<Table>] " 
            <If Loop>
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNull>
                + "LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNull>
                + "LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNotNull>
                + "INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNotNull>
                + "INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
            </If Loop>
                    + "WHERE " 
<If Loop>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow=[0]>
                    + "     (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] >= LTRIM(RTRIM(@<RDisplayField><MiscTag>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
                    + "AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] >= LTRIM(RTRIM(@<RDisplayField><MiscTag>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
                    + "     (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] >= LTRIM(RTRIM(@<RDisplayField>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
                    + "AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] >= LTRIM(RTRIM(@<RDisplayField>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
                    + "     (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] >= LTRIM(RTRIM(@<Field>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
                    + "AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] >= LTRIM(RTRIM(@<Field>))) " 
</If Loop>
                    + "";
            } else if (sCondition == "Equal or less than...") {
                selectStatement 
                    = "SELECT "
            <If Loop>
               <IsRelated>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow=[0]>
                + "     [A<MiscTag>].[<Field>] as [<Field><MiscTag>]"
               <IsRelated>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow<>[0]>
                + "    ,[A<MiscTag>].[<Field>] as [<Field><MiscTag>]"
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow=[0]>
                + "     [<Owner>].[<Table>].[<Field>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow<>[0]>
                + "    ,[<Owner>].[<Table>].[<Field>] "
               <IsNotRelated>
               <And>
               <IsCurRow=[0]>
                + "     [<Owner>].[<Table>].[<Field>] "
               <IsNotRelated>
               <And>
               <IsCurRow<>[0]>
                + "    ,[<Owner>].[<Table>].[<Field>] "
            </If Loop>
                + "FROM " 
                + "     [<Owner>].[<Table>] " 
            <If Loop>
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNull>
                + "LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNull>
                + "LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNotNull>
                + "INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNotNull>
                + "INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
            </If Loop>
                    + "WHERE " 
<If Loop>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow=[0]>
                    + "     (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] <= LTRIM(RTRIM(@<RDisplayField><MiscTag>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
                    + "AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] <= LTRIM(RTRIM(@<RDisplayField><MiscTag>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
                    + "     (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] <= LTRIM(RTRIM(@<RDisplayField>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
                    + "AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] <= LTRIM(RTRIM(@<RDisplayField>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
                    + "     (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] <= LTRIM(RTRIM(@<Field>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
                    + "AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] <= LTRIM(RTRIM(@<Field>))) " 
</If Loop>
                    + "";
            }
            SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
            selectCommand.CommandType = CommandType.Text;
    <If Loop>
   	<IsNotText>
   	<And>
   	<IsNotNText>
        <And>
        <IsRelated>
	       <And>
	       <IsMiscTag>
            if (sField == "<FieldC>") {
                selectCommand.Parameters.AddWithValue("@<RDisplayField><MiscTag>", sValue);
            } else {
                selectCommand.Parameters.AddWithValue("@<RDisplayField><MiscTag>", DBNull.Value); }
   	<IsNotText>
   	<And>
   	<IsNotNText>
        <And>
        <IsRelated>
	       <And>
	       <IsNotMiscTag>
            if (sField == "<FieldC>") {
                selectCommand.Parameters.AddWithValue("@<RDisplayField>", sValue);
            } else {
                selectCommand.Parameters.AddWithValue("@<RDisplayField>", DBNull.Value); }
   	<IsNotText>
   	<And>
   	<IsNotNText>
        <And>
        <IsNotRelated>
            if (sField == "<FieldC>") {
                selectCommand.Parameters.AddWithValue("@<FieldU>", sValue);
            } else {
                selectCommand.Parameters.AddWithValue("@<FieldU>", DBNull.Value); }
    </If Loop>
            DataTable dt = new DataTable();
            try
            {
                connection.Open();
                SqlDataReader reader = selectCommand.ExecuteReader();
                if (reader.HasRows) {
                    dt.Load(reader); }
                reader.Close();
            }
            catch (SqlException)
            {
                return dt;
            }
            finally
            {
                connection.Close();
            }
            return dt;
        }

        public static <TableU> Select_Record(<TableU> <TableU>Para)
        {
        <TableU> <TableU> = new <TableU>();
            SqlConnection connection = <Database>Data.GetConnection();
            string selectStatement
            = "SELECT " 
            <Loop>
                + "    <SF[,]>[<Field>] "
            </Loop>
                + "FROM "
                + "     [<Owner>].[<Table>] "
                + "WHERE "
            <If Loop>
               <IsPKey>
                + " <SF[AND ]>[<Field>] = @<Field> "
            </If Loop>
            <If Loop>
               <IsNotPKey>
               <And>
               <IsIdentity>
                + "    [<Field>] = @<Field> "
            </If Loop>
            <If Loop>
               <IsNotIdentityCount>
               <And>
               <IsNotPKeyCount>
   	       <And>
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
                + "    [<Field>] = @<Field> "
               <ExitLoop>            
            </If Loop>
                + "";
            SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
            selectCommand.CommandType = CommandType.Text;
        <If Loop>
           <IsPKey>
            selectCommand.Parameters.AddWithValue("@<FieldU>", <TableU>Para.<FieldU>);
        </If Loop>
        <If Loop>
           <IsNotPKey>
           <And>
           <IsIdentity>
            selectCommand.Parameters.AddWithValue("@<FieldU>", <TableU>Para.<FieldU>);
        </If Loop>
        <If Loop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
   	   <And>
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
            selectCommand.Parameters.AddWithValue("@<FieldU>", <TableU>Para.<FieldU>);
           <ExitLoop>
        </If Loop>
            try
            {
                connection.Open();
                SqlDataReader reader
                    = selectCommand.ExecuteReader(CommandBehavior.SingleRow);
                if (reader.Read())
                {
                <If Loop>
                    <IsNull>
                    <And>
                    <IsNullable>
                    <And>
                    <IsFloat>
                    <TableU>.<FieldU> = reader["<Field>"] is DBNull ? null : (Decimal?)(Double?)reader["<Field>"];
                    <IsNull>
                    <And>
                    <IsNullable>
                    <And>
                    <IsReal>
                    <TableU>.<FieldU> = reader["<Field>"] is DBNull ? null : (Decimal?)(Single?)reader["<Field>"];
                    <IsNull>
                    <And>
                    <IsNullable>
                    <And>
                    <IsNotFloat>
                    <And>
                    <IsNotReal>
                    <TableU>.<FieldU> = reader["<Field>"] is DBNull ? null : (<VBType>?)reader["<Field>"];
                    <IsNull>
                    <And>
                    <IsNotNullable>
                    <TableU>.<FieldU> = reader["<Field>"] is DBNull ? null : reader["<Field>"].ToString();
                    <IsNotNull>
                    <TableU>.<FieldU> = <Convert>(reader["<Field>"]);
                </If Loop>
                }
                else
                {
                    <TableU> = null;
                }
                reader.Close();
            }
            catch (SqlException)
            {
                return <TableU>;
            }
            finally
            {
                connection.Close();
            }
            return <TableU>;
        }

        public static bool Add(<TableU> <TableU>)
        {
            SqlConnection connection = <Database>Data.GetConnection();
            string insertStatement
                = "INSERT " 
                + "     [<Owner>].[<Table>] "
                + "     ( "
            <If Loop>
               <IsNotIdentity>
                + "    <SF[,]>[<Field>] "
            </If Loop>
                + "     ) "
                + "VALUES " 
                + "     ( "
            <If Loop>
               <IsNotIdentity>
                + "    <SF[,]>@<Field> "
            </If Loop>
                + "     ) "
                + "";
            SqlCommand insertCommand = new SqlCommand(insertStatement, connection);
            insertCommand.CommandType = CommandType.Text;
        <If Loop>
           <IsNotIdentity>
           <And>
           <IsNull>
           <And>
           <IsNullable>
            if (<TableU>.<FieldU>.HasValue == true) {
                insertCommand.Parameters.AddWithValue("@<FieldU>", <TableU>.<FieldU>);
            } else {
                insertCommand.Parameters.AddWithValue("@<FieldU>", DBNull.Value); }
           <IsNotIdentity>
           <And>
           <IsNull>
           <And>
           <IsNotNullable>
            if (<TableU>.<FieldU> != null) {
                insertCommand.Parameters.AddWithValue("@<FieldU>", <TableU>.<FieldU>);
            } else {
                insertCommand.Parameters.AddWithValue("@<FieldU>", DBNull.Value); }
           <IsNotIdentity>
           <And>
           <IsNotNull>
                insertCommand.Parameters.AddWithValue("@<FieldU>", <TableU>.<FieldU>);
        </If Loop>
            try
            {
                connection.Open();
                int count = insertCommand.ExecuteNonQuery();
                if (count > 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
            catch (SqlException)
            {
                return false;
            }
            finally
            {
                connection.Close();
            }
        }

        public static bool Update(<TableU> old<TableU>, 
               <TableU> new<TableU>)
        {
            SqlConnection connection = <Database>Data.GetConnection();
            string updateStatement
                = "UPDATE "  
                + "     [<Owner>].[<Table>] "
                + "SET "
            <If Loop>
               <IsNotIdentity>
                + "    <SF[,]>[<Field>] = @New<Field> "
            </If Loop>
                + "WHERE "
            <If Loop>
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNotNull>
               <And>
               <IsCurRow=[0]>
                + "     [<Field>] = @Old<Field> " 
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNotNull>
               <And>
               <IsCurRow<>[0]>
                + " AND [<Field>] = @Old<Field> " 
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNull>
               <And>
               <IsCurRow=[0]>
                + "     ((@Old<FieldU> IS NULL AND [<Field>] IS NULL) OR [<Field>] = @Old<Field>) " 
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNull>
               <And>
               <IsCurRow<>[0]>
                + " AND ((@Old<FieldU> IS NULL AND [<Field>] IS NULL) OR [<Field>] = @Old<Field>) " 
            </If Loop>
                + "";
            SqlCommand updateCommand = new SqlCommand(updateStatement, connection);
            updateCommand.CommandType = CommandType.Text;
        <If Loop>
           <IsNotIdentity>
           <And>
           <IsNull>
           <And>
           <IsNullable>
            if (new<TableU>.<FieldU>.HasValue == true) {
                updateCommand.Parameters.AddWithValue("@New<FieldU>", new<TableU>.<FieldU>);
            } else {
                updateCommand.Parameters.AddWithValue("@New<FieldU>", DBNull.Value); }
           <IsNotIdentity>
           <And>
           <IsNull>
           <And>
           <IsNotNullable>
            if (new<TableU>.<FieldU> != null) {
                updateCommand.Parameters.AddWithValue("@New<FieldU>", new<TableU>.<FieldU>);
            } else {
                updateCommand.Parameters.AddWithValue("@New<FieldU>", DBNull.Value); }
           <IsNotIdentity>
           <And>
           <IsNotNull>
            updateCommand.Parameters.AddWithValue("@New<FieldU>", new<TableU>.<FieldU>);
        </If Loop>
        <If Loop>
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNotNull>
            updateCommand.Parameters.AddWithValue("@Old<FieldU>", old<TableU>.<FieldU>);
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNull>
           <And>
           <IsNullable>
            if (old<TableU>.<FieldU>.HasValue == true) {
                updateCommand.Parameters.AddWithValue("@Old<FieldU>", old<TableU>.<FieldU>);
            } else {
                updateCommand.Parameters.AddWithValue("@Old<FieldU>", DBNull.Value); }
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNull>
           <And>
           <IsNotNullable>
            if (old<TableU>.<FieldU> != null) {
                updateCommand.Parameters.AddWithValue("@Old<FieldU>", old<TableU>.<FieldU>);
            } else {
                updateCommand.Parameters.AddWithValue("@Old<FieldU>", DBNull.Value); }
        </If Loop>
            try
            {
                connection.Open();
                int count = updateCommand.ExecuteNonQuery();
                if (count > 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
            catch (SqlException)
            {
                return false;
            }
            finally
            {
                connection.Close();
            }
        }

        public static bool Delete(<TableU> <TableU>)
        {
            SqlConnection connection = <Database>Data.GetConnection();
            string deleteStatement
                = "DELETE FROM "  
                + "     [<Owner>].[<Table>] "
                + "WHERE " 
            <If Loop>
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNotNull>
               <And>
               <IsCurRow=[0]>
                + "     [<Field>] = @Old<Field> " 
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNotNull>
               <And>
               <IsCurRow<>[0]>
                + " AND [<Field>] = @Old<Field> " 
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNull>
               <And>
               <IsCurRow=[0]>
                + "     ((@Old<FieldU> IS NULL AND [<Field>] IS NULL) OR [<Field>] = @Old<Field>) " 
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNull>
               <And>
               <IsCurRow<>[0]>
                + " AND ((@Old<FieldU> IS NULL AND [<Field>] IS NULL) OR [<Field>] = @Old<Field>) " 
            </If Loop>
                + "";
            SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection);
            deleteCommand.CommandType = CommandType.Text;
        <If Loop>
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNotNull>
            deleteCommand.Parameters.AddWithValue("@Old<FieldU>", <TableU>.<FieldU>);
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNull>
           <And>
           <IsNullable>
            if (<TableU>.<FieldU>.HasValue == true) {
                deleteCommand.Parameters.AddWithValue("@Old<FieldU>", <TableU>.<FieldU>);
            } else {
                deleteCommand.Parameters.AddWithValue("@Old<FieldU>", DBNull.Value); }
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNull>
           <And>
           <IsNotNullable>
            if (<TableU>.<FieldU> != null) {
                deleteCommand.Parameters.AddWithValue("@Old<FieldU>", <TableU>.<FieldU>);
            } else {
                deleteCommand.Parameters.AddWithValue("@Old<FieldU>", DBNull.Value); }
        </If Loop>
            try
            {
                connection.Open();
                int count = deleteCommand.ExecuteNonQuery();
                if (count > 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
            catch (SqlException)
            {
                return false;
            }
            finally
            {
                connection.Close();
            }
        }
    }
}
